<?php

use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;

return new class extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::create('search', function (Blueprint $table) {
            $table->increments('id');
            $table->integer('uid')->comment('会员id')->default('0');
            $table->string('city')->comment('城市')->default('');
            $table->integer('min_age')->comment('最低年龄')->default('0');
            $table->integer('max_age')->comment('最高年龄')->default('99');
            $table->integer('min_height')->comment('最低身高')->default('0');
            $table->integer('max_height')->comment('最高身高')->default('200');
            $table->string('min_education')->comment('最低学历')->default('小学');
            $table->string('max_education')->comment('最高学历')->default('博士');
            $table->string('keyword')->comment('关键字')->default('');
            $table->tinyInteger('status')->comment('状态,(0:未支付, 1:已支付, 2:已完成)');
            $table->timestamps();
        });
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Schema::dropIfExists('search');
    }
};
